USE [master]
GO

/****** Object:  Database [{1}]    Script Date: 07/23/2011 12:11:13 ******/
CREATE DATABASE [{1}] ON  PRIMARY 
( NAME = N'{1}', FILENAME = N'{0}\{1}.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'{1}_log', FILENAME = N'{0}\{1}_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

EXEC dbo.sp_dbcmptlevel @dbname=N'{1}', @new_cmptlevel=90
GO

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [{1}].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO

ALTER DATABASE [{1}] SET ANSI_NULL_DEFAULT OFF 
GO

ALTER DATABASE [{1}] SET ANSI_NULLS OFF 
GO

ALTER DATABASE [{1}] SET ANSI_PADDING OFF 
GO

ALTER DATABASE [{1}] SET ANSI_WARNINGS OFF 
GO

ALTER DATABASE [{1}] SET ARITHABORT OFF 
GO

ALTER DATABASE [{1}] SET AUTO_CLOSE OFF 
GO

ALTER DATABASE [{1}] SET AUTO_CREATE_STATISTICS ON 
GO

ALTER DATABASE [{1}] SET AUTO_SHRINK OFF 
GO

ALTER DATABASE [{1}] SET AUTO_UPDATE_STATISTICS ON 
GO

ALTER DATABASE [{1}] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO

ALTER DATABASE [{1}] SET CURSOR_DEFAULT  GLOBAL 
GO

ALTER DATABASE [{1}] SET CONCAT_NULL_YIELDS_NULL OFF 
GO

ALTER DATABASE [{1}] SET NUMERIC_ROUNDABORT OFF 
GO

ALTER DATABASE [{1}] SET QUOTED_IDENTIFIER OFF 
GO

ALTER DATABASE [{1}] SET RECURSIVE_TRIGGERS OFF 
GO

ALTER DATABASE [{1}] SET  DISABLE_BROKER 
GO

ALTER DATABASE [{1}] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO

ALTER DATABASE [{1}] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO

ALTER DATABASE [{1}] SET TRUSTWORTHY OFF 
GO

ALTER DATABASE [{1}] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO

ALTER DATABASE [{1}] SET PARAMETERIZATION SIMPLE 
GO

ALTER DATABASE [{1}] SET READ_COMMITTED_SNAPSHOT OFF 
GO

ALTER DATABASE [{1}] SET  READ_WRITE 
GO

ALTER DATABASE [{1}] SET RECOVERY SIMPLE 
GO

ALTER DATABASE [{1}] SET  MULTI_USER 
GO

ALTER DATABASE [{1}] SET PAGE_VERIFY CHECKSUM  
GO

ALTER DATABASE [{1}] SET DB_CHAINING OFF 
GO


